﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="MeterData" targetNamespace="http://tempuri.org/MeterData.xsd" xmlns:mstns="http://tempuri.org/MeterData.xsd" xmlns="http://tempuri.org/MeterData.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="1" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="openXDAConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Public" Name="openXDAConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.FaultData.Properties.Settings.GlobalReference.Default.openXDAConnectionString" Provider="System.Data.SqlClient" />
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="openXDAConnectionString1" IsAppSettingsProperty="true" Modifier="Assembly" Name="openXDAConnectionString1 (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.FaultData.Properties.Settings.GlobalReference.Default.openXDAConnectionString1" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="EventTypeTableAdapter" GeneratorDataComponentClassName="EventTypeTableAdapter" Name="EventType" UserDataComponentName="EventTypeTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="openXDAConnectionString (Settings)" DbObjectName="MeterDB.dbo.EventType" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[EventType] WHERE (([ID] = @Original_ID) AND ([Name] = @Original_Name))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[EventType] ([Name], [Description]) VALUES (@Name, @Description);
SELECT ID, Name, Description FROM EventType WHERE (ID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Description" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID, Name, Description FROM dbo.EventType</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[EventType] SET [Name] = @Name, [Description] = @Description WHERE (([ID] = @Original_ID) AND ([Name] = @Original_Name));
SELECT ID, Name, Description FROM EventType WHERE (ID = @ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Description" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="ID" ColumnName="ID" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="Name" DataSetColumn="Name" />
              <Mapping SourceColumn="Description" DataSetColumn="Description" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ChannelNormalTableAdapter" GeneratorDataComponentClassName="ChannelNormalTableAdapter" Name="ChannelNormal" UserDataComponentName="ChannelNormalTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="openXDAConnectionString (Settings)" DbObjectName="openXDA.dbo.ChannelNormal" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[ChannelNormal] WHERE (([ID] = @Original_ID) AND ([ChannelID] = @Original_ChannelID) AND ([Average] = @Original_Average) AND ([MeanSquare] = @Original_MeanSquare) AND ([StandardDeviation] = @Original_StandardDeviation) AND ([Count] = @Original_Count))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ChannelID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ChannelID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_Average" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Average" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_MeanSquare" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="MeanSquare" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_StandardDeviation" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="StandardDeviation" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Count" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Count" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[ChannelNormal] ([ChannelID], [Average], [MeanSquare], [StandardDeviation], [Count]) VALUES (@ChannelID, @Average, @MeanSquare, @StandardDeviation, @Count);
SELECT ID, ChannelID, Average, MeanSquare, StandardDeviation, Count FROM ChannelNormal WHERE (ID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ChannelID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ChannelID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Average" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Average" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@MeanSquare" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="MeanSquare" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@StandardDeviation" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="StandardDeviation" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Count" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Count" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID, ChannelID, Average, MeanSquare, StandardDeviation, Count FROM dbo.ChannelNormal</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[ChannelNormal] SET [ChannelID] = @ChannelID, [Average] = @Average, [MeanSquare] = @MeanSquare, [StandardDeviation] = @StandardDeviation, [Count] = @Count WHERE (([ID] = @Original_ID) AND ([ChannelID] = @Original_ChannelID) AND ([Average] = @Original_Average) AND ([MeanSquare] = @Original_MeanSquare) AND ([StandardDeviation] = @Original_StandardDeviation) AND ([Count] = @Original_Count));
SELECT ID, ChannelID, Average, MeanSquare, StandardDeviation, Count FROM ChannelNormal WHERE (ID = @ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ChannelID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ChannelID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Average" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Average" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@MeanSquare" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="MeanSquare" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@StandardDeviation" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="StandardDeviation" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Count" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Count" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ChannelID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ChannelID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_Average" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Average" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_MeanSquare" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="MeanSquare" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_StandardDeviation" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="StandardDeviation" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Count" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Count" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="ID" ColumnName="ID" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="ChannelID" DataSetColumn="ChannelID" />
              <Mapping SourceColumn="Average" DataSetColumn="Average" />
              <Mapping SourceColumn="MeanSquare" DataSetColumn="MeanSquare" />
              <Mapping SourceColumn="StandardDeviation" DataSetColumn="StandardDeviation" />
              <Mapping SourceColumn="Count" DataSetColumn="Count" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="HourlyTrendingSummaryTableAdapter" GeneratorDataComponentClassName="HourlyTrendingSummaryTableAdapter" Name="HourlyTrendingSummary" UserDataComponentName="HourlyTrendingSummaryTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="openXDAConnectionString (Settings)" DbObjectName="openXDA.dbo.HourlyTrendingSummary" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[HourlyTrendingSummary] WHERE (([ID] = @Original_ID) AND ([ChannelID] = @Original_ChannelID) AND ([Time] = @Original_Time) AND ([Minimum] = @Original_Minimum) AND ([Maximum] = @Original_Maximum) AND ([Average] = @Original_Average) AND ([ValidCount] = @Original_ValidCount) AND ([InvalidCount] = @Original_InvalidCount))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ChannelID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ChannelID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_Time" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Time" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_Minimum" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Minimum" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_Maximum" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Maximum" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_Average" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Average" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ValidCount" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ValidCount" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_InvalidCount" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="InvalidCount" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[HourlyTrendingSummary] ([ChannelID], [Time], [Minimum], [Maximum], [Average], [ValidCount], [InvalidCount]) VALUES (@ChannelID, @Time, @Minimum, @Maximum, @Average, @ValidCount, @InvalidCount);
SELECT ID, ChannelID, Time, Minimum, Maximum, Average, ValidCount, InvalidCount FROM HourlyTrendingSummary WHERE (ID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ChannelID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ChannelID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Time" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Time" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Minimum" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Minimum" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Maximum" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Maximum" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Average" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Average" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ValidCount" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ValidCount" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@InvalidCount" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="InvalidCount" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID, ChannelID, Time, Minimum, Maximum, Average, ValidCount, InvalidCount FROM dbo.HourlyTrendingSummary</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[HourlyTrendingSummary] SET [ChannelID] = @ChannelID, [Time] = @Time, [Minimum] = @Minimum, [Maximum] = @Maximum, [Average] = @Average, [ValidCount] = @ValidCount, [InvalidCount] = @InvalidCount WHERE (([ID] = @Original_ID) AND ([ChannelID] = @Original_ChannelID) AND ([Time] = @Original_Time) AND ([Minimum] = @Original_Minimum) AND ([Maximum] = @Original_Maximum) AND ([Average] = @Original_Average) AND ([ValidCount] = @Original_ValidCount) AND ([InvalidCount] = @Original_InvalidCount));
SELECT ID, ChannelID, Time, Minimum, Maximum, Average, ValidCount, InvalidCount FROM HourlyTrendingSummary WHERE (ID = @ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ChannelID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ChannelID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Time" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Time" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Minimum" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Minimum" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Maximum" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Maximum" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Average" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Average" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ValidCount" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ValidCount" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@InvalidCount" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="InvalidCount" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ChannelID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ChannelID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_Time" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Time" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_Minimum" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Minimum" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_Maximum" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Maximum" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_Average" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Average" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ValidCount" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ValidCount" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_InvalidCount" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="InvalidCount" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="ID" ColumnName="ID" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="ChannelID" DataSetColumn="ChannelID" />
              <Mapping SourceColumn="Time" DataSetColumn="Time" />
              <Mapping SourceColumn="Minimum" DataSetColumn="Minimum" />
              <Mapping SourceColumn="Maximum" DataSetColumn="Maximum" />
              <Mapping SourceColumn="Average" DataSetColumn="Average" />
              <Mapping SourceColumn="ValidCount" DataSetColumn="ValidCount" />
              <Mapping SourceColumn="InvalidCount" DataSetColumn="InvalidCount" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="openXDAConnectionString (Settings)" DbObjectName="openXDA.dbo.HourlyTrendingSummary" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillBy" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataBy" GeneratorSourceName="FillBy" GetMethodModifier="Public" GetMethodName="GetDataBy" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="FillBy">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT ID, ChannelID, Time, Minimum, Maximum, Average, ValidCount, InvalidCount FROM dbo.HourlyTrendingSummary WITH (TABLOCK) WHERE ChannelID = @channelID AND Time &gt; @startTime AND Time &lt;= @endTime</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="channelID" ColumnName="ChannelID" DataSourceName="openXDA.dbo.HourlyTrendingSummary" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@channelID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ChannelID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="startTime" ColumnName="Time" DataSourceName="openXDA.dbo.HourlyTrendingSummary" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@startTime" Precision="0" ProviderType="DateTime" Scale="0" Size="8" SourceColumn="Time" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="endTime" ColumnName="Time" DataSourceName="openXDA.dbo.HourlyTrendingSummary" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@endTime" Precision="0" ProviderType="DateTime" Scale="0" Size="8" SourceColumn="Time" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="DailyTrendingSummaryTableAdapter" GeneratorDataComponentClassName="DailyTrendingSummaryTableAdapter" Name="DailyTrendingSummary" UserDataComponentName="DailyTrendingSummaryTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="openXDAConnectionString (Settings)" DbObjectName="openXDA.dbo.DailyTrendingSummary" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[DailyTrendingSummary] WHERE (([ID] = @Original_ID) AND ([ChannelID] = @Original_ChannelID) AND ([Date] = @Original_Date) AND ([Minimum] = @Original_Minimum) AND ([Maximum] = @Original_Maximum) AND ([Average] = @Original_Average) AND ([ValidCount] = @Original_ValidCount) AND ([InvalidCount] = @Original_InvalidCount))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ChannelID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ChannelID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_Date" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Date" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_Minimum" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Minimum" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_Maximum" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Maximum" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_Average" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Average" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ValidCount" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ValidCount" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_InvalidCount" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="InvalidCount" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[DailyTrendingSummary] ([ChannelID], [Date], [Minimum], [Maximum], [Average], [ValidCount], [InvalidCount]) VALUES (@ChannelID, @Date, @Minimum, @Maximum, @Average, @ValidCount, @InvalidCount);
SELECT ID, ChannelID, Date, Minimum, Maximum, Average, ValidCount, InvalidCount FROM DailyTrendingSummary WHERE (ID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ChannelID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ChannelID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Date" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Date" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Minimum" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Minimum" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Maximum" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Maximum" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Average" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Average" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ValidCount" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ValidCount" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@InvalidCount" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="InvalidCount" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID, ChannelID, Date, Minimum, Maximum, Average, ValidCount, InvalidCount FROM dbo.DailyTrendingSummary</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[DailyTrendingSummary] SET [ChannelID] = @ChannelID, [Date] = @Date, [Minimum] = @Minimum, [Maximum] = @Maximum, [Average] = @Average, [ValidCount] = @ValidCount, [InvalidCount] = @InvalidCount WHERE (([ID] = @Original_ID) AND ([ChannelID] = @Original_ChannelID) AND ([Date] = @Original_Date) AND ([Minimum] = @Original_Minimum) AND ([Maximum] = @Original_Maximum) AND ([Average] = @Original_Average) AND ([ValidCount] = @Original_ValidCount) AND ([InvalidCount] = @Original_InvalidCount));
SELECT ID, ChannelID, Date, Minimum, Maximum, Average, ValidCount, InvalidCount FROM DailyTrendingSummary WHERE (ID = @ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ChannelID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ChannelID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Date" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Date" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Minimum" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Minimum" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Maximum" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Maximum" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Average" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Average" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ValidCount" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ValidCount" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@InvalidCount" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="InvalidCount" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ChannelID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ChannelID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_Date" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Date" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_Minimum" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Minimum" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_Maximum" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Maximum" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_Average" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Average" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ValidCount" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ValidCount" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_InvalidCount" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="InvalidCount" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="ID" ColumnName="ID" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="ChannelID" DataSetColumn="ChannelID" />
              <Mapping SourceColumn="Date" DataSetColumn="Date" />
              <Mapping SourceColumn="Minimum" DataSetColumn="Minimum" />
              <Mapping SourceColumn="Maximum" DataSetColumn="Maximum" />
              <Mapping SourceColumn="Average" DataSetColumn="Average" />
              <Mapping SourceColumn="ValidCount" DataSetColumn="ValidCount" />
              <Mapping SourceColumn="InvalidCount" DataSetColumn="InvalidCount" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="openXDAConnectionString (Settings)" DbObjectName="openXDA.dbo.DailyTrendingSummary" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillBy" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataBy" GeneratorSourceName="FillBy" GetMethodModifier="Public" GetMethodName="GetDataBy" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="FillBy">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT ID, ChannelID, Date, Minimum, Maximum, Average, ValidCount, InvalidCount FROM dbo.DailyTrendingSummary WHERE ChannelID = @channelID AND Date &gt; @startDate AND Date &lt;= @endDate</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="channelID" ColumnName="ChannelID" DataSourceName="openXDA.dbo.DailyTrendingSummary" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@channelID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ChannelID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="startDate" ColumnName="Date" DataSourceName="openXDA.dbo.DailyTrendingSummary" DataTypeServer="date" DbType="AnsiString" Direction="Input" ParameterName="@startDate" Precision="0" ProviderType="Date" Scale="0" Size="3" SourceColumn="Date" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="endDate" ColumnName="Date" DataSourceName="openXDA.dbo.DailyTrendingSummary" DataTypeServer="date" DbType="AnsiString" Direction="Input" ParameterName="@endDate" Precision="0" ProviderType="Date" Scale="0" Size="3" SourceColumn="Date" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="CycleDataTableAdapter" GeneratorDataComponentClassName="CycleDataTableAdapter" Name="CycleData" UserDataComponentName="CycleDataTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="openXDAConnectionString (Settings)" DbObjectName="openXDA.dbo.CycleData" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[CycleData] WHERE (([ID] = @Original_ID) AND ([EventID] = @Original_EventID))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_EventID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EventID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[CycleData] ([EventID], [Data]) VALUES (@EventID, @Data);
SELECT ID, EventID, Data FROM CycleData WHERE (ID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@EventID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EventID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@Data" Precision="0" ProviderType="VarBinary" Scale="0" Size="0" SourceColumn="Data" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID, EventID, Data FROM dbo.CycleData</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[CycleData] SET [EventID] = @EventID, [Data] = @Data WHERE (([ID] = @Original_ID) AND ([EventID] = @Original_EventID));
SELECT ID, EventID, Data FROM CycleData WHERE (ID = @ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@EventID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EventID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@Data" Precision="0" ProviderType="VarBinary" Scale="0" Size="0" SourceColumn="Data" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_EventID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EventID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="ID" ColumnName="ID" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="EventID" DataSetColumn="EventID" />
              <Mapping SourceColumn="Data" DataSetColumn="Data" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="openXDAConnectionString (Settings)" DbObjectName="openXDA.dbo.CycleData" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillBy" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataBy" GeneratorSourceName="FillBy" GetMethodModifier="Public" GetMethodName="GetDataBy" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="FillBy">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT ID, EventID, Data FROM dbo.CycleData WHERE EventID = @eventID</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="eventID" ColumnName="EventID" DataSourceName="openXDA.dbo.CycleData" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@eventID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="EventID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="EventTableAdapter" GeneratorDataComponentClassName="EventTableAdapter" Name="Event" UserDataComponentName="EventTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="openXDAConnectionString (Settings)" DbObjectName="openXDA.dbo.Event" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Event] WHERE (([ID] = @Original_ID) AND ([FileGroupID] = @Original_FileGroupID) AND ([MeterID] = @Original_MeterID) AND ([LineID] = @Original_LineID) AND ([EventTypeID] = @Original_EventTypeID) AND ([Name] = @Original_Name) AND ((@IsNull_Alias = 1 AND [Alias] IS NULL) OR ([Alias] = @Original_Alias)) AND ((@IsNull_ShortName = 1 AND [ShortName] IS NULL) OR ([ShortName] = @Original_ShortName)) AND ([StartTime] = @Original_StartTime) AND ([EndTime] = @Original_EndTime) AND ([TimeZoneOffset] = @Original_TimeZoneOffset) AND ([Magnitude] = @Original_Magnitude) AND ([Duration] = @Original_Duration) AND ([HasImpactedComponents] = @Original_HasImpactedComponents))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_FileGroupID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FileGroupID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_MeterID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MeterID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_LineID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="LineID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_EventTypeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EventTypeID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Alias" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Alias" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Alias" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Alias" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ShortName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ShortName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ShortName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ShortName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime2" Direction="Input" ParameterName="@Original_StartTime" Precision="0" ProviderType="DateTime2" Scale="0" Size="0" SourceColumn="StartTime" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime2" Direction="Input" ParameterName="@Original_EndTime" Precision="0" ProviderType="DateTime2" Scale="0" Size="0" SourceColumn="EndTime" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_TimeZoneOffset" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TimeZoneOffset" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_Magnitude" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Magnitude" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_Duration" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Duration" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_HasImpactedComponents" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="HasImpactedComponents" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Event] ([FileGroupID], [MeterID], [LineID], [EventTypeID], [Name], [Alias], [ShortName], [StartTime], [EndTime], [TimeZoneOffset], [Magnitude], [Duration], [HasImpactedComponents], [Description], [Data]) VALUES (@FileGroupID, @MeterID, @LineID, @EventTypeID, @Name, @Alias, @ShortName, @StartTime, @EndTime, @TimeZoneOffset, @Magnitude, @Duration, @HasImpactedComponents, @Description, @Data);
SELECT ID, FileGroupID, MeterID, LineID, EventTypeID, Name, Alias, ShortName, StartTime, EndTime, TimeZoneOffset, Magnitude, Duration, HasImpactedComponents, Description, Data FROM Event WHERE (ID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@FileGroupID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FileGroupID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@MeterID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MeterID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@LineID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="LineID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@EventTypeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EventTypeID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Alias" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Alias" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ShortName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ShortName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime2" Direction="Input" ParameterName="@StartTime" Precision="0" ProviderType="DateTime2" Scale="0" Size="0" SourceColumn="StartTime" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime2" Direction="Input" ParameterName="@EndTime" Precision="0" ProviderType="DateTime2" Scale="0" Size="0" SourceColumn="EndTime" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@TimeZoneOffset" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TimeZoneOffset" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Magnitude" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Magnitude" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Duration" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Duration" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@HasImpactedComponents" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="HasImpactedComponents" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Description" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@Data" Precision="0" ProviderType="VarBinary" Scale="0" Size="0" SourceColumn="Data" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID, FileGroupID, MeterID, LineID, EventTypeID, Name, Alias, ShortName, StartTime, EndTime, TimeZoneOffset, Magnitude, Duration, HasImpactedComponents, Description, Data FROM dbo.Event</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Event] SET [FileGroupID] = @FileGroupID, [MeterID] = @MeterID, [LineID] = @LineID, [EventTypeID] = @EventTypeID, [Name] = @Name, [Alias] = @Alias, [ShortName] = @ShortName, [StartTime] = @StartTime, [EndTime] = @EndTime, [TimeZoneOffset] = @TimeZoneOffset, [Magnitude] = @Magnitude, [Duration] = @Duration, [HasImpactedComponents] = @HasImpactedComponents, [Description] = @Description, [Data] = @Data WHERE (([ID] = @Original_ID) AND ([FileGroupID] = @Original_FileGroupID) AND ([MeterID] = @Original_MeterID) AND ([LineID] = @Original_LineID) AND ([EventTypeID] = @Original_EventTypeID) AND ([Name] = @Original_Name) AND ((@IsNull_Alias = 1 AND [Alias] IS NULL) OR ([Alias] = @Original_Alias)) AND ((@IsNull_ShortName = 1 AND [ShortName] IS NULL) OR ([ShortName] = @Original_ShortName)) AND ([StartTime] = @Original_StartTime) AND ([EndTime] = @Original_EndTime) AND ([TimeZoneOffset] = @Original_TimeZoneOffset) AND ([Magnitude] = @Original_Magnitude) AND ([Duration] = @Original_Duration) AND ([HasImpactedComponents] = @Original_HasImpactedComponents));
SELECT ID, FileGroupID, MeterID, LineID, EventTypeID, Name, Alias, ShortName, StartTime, EndTime, TimeZoneOffset, Magnitude, Duration, HasImpactedComponents, Description, Data FROM Event WHERE (ID = @ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@FileGroupID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FileGroupID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@MeterID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MeterID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@LineID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="LineID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@EventTypeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EventTypeID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Alias" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Alias" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ShortName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ShortName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime2" Direction="Input" ParameterName="@StartTime" Precision="0" ProviderType="DateTime2" Scale="0" Size="0" SourceColumn="StartTime" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime2" Direction="Input" ParameterName="@EndTime" Precision="0" ProviderType="DateTime2" Scale="0" Size="0" SourceColumn="EndTime" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@TimeZoneOffset" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TimeZoneOffset" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Magnitude" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Magnitude" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Duration" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Duration" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@HasImpactedComponents" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="HasImpactedComponents" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Description" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@Data" Precision="0" ProviderType="VarBinary" Scale="0" Size="0" SourceColumn="Data" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_FileGroupID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FileGroupID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_MeterID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MeterID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_LineID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="LineID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_EventTypeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EventTypeID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Alias" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Alias" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Alias" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Alias" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ShortName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ShortName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ShortName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ShortName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime2" Direction="Input" ParameterName="@Original_StartTime" Precision="0" ProviderType="DateTime2" Scale="0" Size="0" SourceColumn="StartTime" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime2" Direction="Input" ParameterName="@Original_EndTime" Precision="0" ProviderType="DateTime2" Scale="0" Size="0" SourceColumn="EndTime" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_TimeZoneOffset" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TimeZoneOffset" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_Magnitude" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Magnitude" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_Duration" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Duration" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_HasImpactedComponents" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="HasImpactedComponents" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="ID" ColumnName="ID" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="FileGroupID" DataSetColumn="FileGroupID" />
              <Mapping SourceColumn="MeterID" DataSetColumn="MeterID" />
              <Mapping SourceColumn="LineID" DataSetColumn="LineID" />
              <Mapping SourceColumn="EventTypeID" DataSetColumn="EventTypeID" />
              <Mapping SourceColumn="Name" DataSetColumn="Name" />
              <Mapping SourceColumn="Alias" DataSetColumn="Alias" />
              <Mapping SourceColumn="ShortName" DataSetColumn="ShortName" />
              <Mapping SourceColumn="StartTime" DataSetColumn="StartTime" />
              <Mapping SourceColumn="EndTime" DataSetColumn="EndTime" />
              <Mapping SourceColumn="TimeZoneOffset" DataSetColumn="TimeZoneOffset" />
              <Mapping SourceColumn="Magnitude" DataSetColumn="Magnitude" />
              <Mapping SourceColumn="Duration" DataSetColumn="Duration" />
              <Mapping SourceColumn="HasImpactedComponents" DataSetColumn="HasImpactedComponents" />
              <Mapping SourceColumn="Description" DataSetColumn="Description" />
              <Mapping SourceColumn="Data" DataSetColumn="Data" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="openXDAConnectionString (Settings)" DbObjectName="openXDA.dbo.Event" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByFileGroup" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByFileGroup" GeneratorSourceName="FillByFileGroup" GetMethodModifier="Public" GetMethodName="GetDataByFileGroup" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByFileGroup" UserSourceName="FillByFileGroup">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT ID, FileGroupID, MeterID, LineID, EventTypeID, Name, Alias, ShortName, StartTime, EndTime, TimeZoneOffset, Magnitude, Duration, HasImpactedComponents, Description, Data FROM dbo.Event WHERE FileGroupID = @fileGroupID</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="fileGroupID" ColumnName="FileGroupID" DataSourceName="openXDA.dbo.Event" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@fileGroupID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="FileGroupID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="openXDAConnectionString (Settings)" DbObjectName="openXDA.dbo.Event" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByID" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByID" GeneratorSourceName="FillByID" GetMethodModifier="Public" GetMethodName="GetDataByID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByID" UserSourceName="FillByID">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT ID, FileGroupID, MeterID, LineID, EventTypeID, Name, Alias, ShortName, StartTime, EndTime, TimeZoneOffset, Magnitude, Duration, HasImpactedComponents, Description, Data FROM dbo.Event WHERE ID = @id</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="id" ColumnName="ID" DataSourceName="openXDA.dbo.Event" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="openXDAConnectionString (Settings)" DbObjectName="openXDA.dbo.EventDetail" DbObjectType="View" GenerateShortCommands="true" GeneratorSourceName="GetEventDetail" Modifier="Public" Name="GetEventDetail" QueryType="Scalar" ScalarCallRetval="System.String, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="GetEventDetail">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT EventDetail FROM EventDetail WHERE EventID = @eventID</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="eventID" ColumnName="EventID" DataSourceName="openXDA.dbo.EventDetail" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@eventID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="EventID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="openXDAConnectionString (Settings)" DbObjectName="openXDA.dbo.Event" DbObjectType="Table" GenerateShortCommands="true" GeneratorSourceName="GetEventIDBy" Modifier="Public" Name="GetEventIDBy" QueryType="Scalar" ScalarCallRetval="System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="GetEventIDBy">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT ID
FROM Event
WHERE MeterID = @meterID AND LineID = @lineID AND FileGroupID = @fileGroupID AND StartTime = @startTime AND EndTime = @endTime</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="meterID" ColumnName="MeterID" DataSourceName="openXDA.dbo.Event" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@meterID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="MeterID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="lineID" ColumnName="LineID" DataSourceName="openXDA.dbo.Event" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@lineID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="LineID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="fileGroupID" ColumnName="FileGroupID" DataSourceName="openXDA.dbo.Event" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@fileGroupID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="FileGroupID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="startTime" ColumnName="StartTime" DataSourceName="openXDA.dbo.Event" DataTypeServer="datetime2" DbType="AnsiString" Direction="Input" ParameterName="@startTime" Precision="0" ProviderType="DateTime2" Scale="0" Size="8" SourceColumn="StartTime" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="endTime" ColumnName="EndTime" DataSourceName="openXDA.dbo.Event" DataTypeServer="datetime2" DbType="AnsiString" Direction="Input" ParameterName="@endTime" Precision="0" ProviderType="DateTime2" Scale="0" Size="8" SourceColumn="EndTime" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="openXDAConnectionString (Settings)" DbObjectName="openXDA.dbo.Event" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="GetFaultsByTimeRange" GetMethodModifier="Public" GetMethodName="GetFaultsByTimeRange" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetFaultsByTimeRange" UserSourceName="GetFaultsByTimeRange">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT dbo.Event.ID, dbo.Event.FileGroupID, dbo.Event.MeterID, dbo.Event.LineID, dbo.Event.EventTypeID, dbo.Event.Name, dbo.Event.Alias, dbo.Event.ShortName, dbo.Event.StartTime, dbo.Event.EndTime, dbo.Event.TimeZoneOffset, dbo.Event.Magnitude, dbo.Event.Duration, dbo.Event.HasImpactedComponents, dbo.Event.Description, Data FROM dbo.Event JOIN dbo.EventType ON dbo.Event.EventTypeID = dbo.EventType.ID WHERE dbo.EventType.Name = 'Fault' AND ((dbo.Event.StartTime &gt;= @minTime AND dbo.Event.StartTime &lt;= @maxTime) OR (@minTime &gt;= dbo.Event.StartTime AND @minTime &lt;= dbo.Event.EndTime))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="minTime" ColumnName="StartTime" DataSourceName="openXDA.dbo.Event" DataTypeServer="datetime2" DbType="AnsiString" Direction="Input" ParameterName="@minTime" Precision="0" ProviderType="DateTime2" Scale="0" Size="8" SourceColumn="StartTime" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="maxTime" ColumnName="StartTime" DataSourceName="openXDA.dbo.Event" DataTypeServer="datetime2" DbType="AnsiString" Direction="Input" ParameterName="@maxTime" Precision="0" ProviderType="DateTime2" Scale="0" Size="8" SourceColumn="StartTime" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="openXDAConnectionString (Settings)" DbObjectName="openXDA.dbo.GetSystemEvent" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="GetSystemEvent" GetMethodModifier="Public" GetMethodName="GetSystemEvent" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetSystemEvent" UserSourceName="GetSystemEvent">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.GetSystemEvent</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="datetime2" DbType="DateTime2" Direction="Input" ParameterName="@startTime" Precision="27" ProviderType="DateTime2" Scale="7" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="datetime2" DbType="DateTime2" Direction="Input" ParameterName="@endTime" Precision="27" ProviderType="DateTime2" Scale="7" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="float" DbType="Double" Direction="Input" ParameterName="@timeTolerance" Precision="53" ProviderType="Float" Scale="0" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="BreakerOperationTypeTableAdapter" GeneratorDataComponentClassName="BreakerOperationTypeTableAdapter" Name="BreakerOperationType" UserDataComponentName="BreakerOperationTypeTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="openXDAConnectionString (Settings)" DbObjectName="openXDA.dbo.BreakerOperationType" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[BreakerOperationType] WHERE (([ID] = @Original_ID) AND ([Name] = @Original_Name))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[BreakerOperationType] ([Name], [Description]) VALUES (@Name, @Description);
SELECT ID, Name, Description FROM BreakerOperationType WHERE (ID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Description" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID, Name, Description FROM dbo.BreakerOperationType</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[BreakerOperationType] SET [Name] = @Name, [Description] = @Description WHERE (([ID] = @Original_ID) AND ([Name] = @Original_Name));
SELECT ID, Name, Description FROM BreakerOperationType WHERE (ID = @ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Description" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="ID" ColumnName="ID" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="Name" DataSetColumn="Name" />
              <Mapping SourceColumn="Description" DataSetColumn="Description" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="BreakerOperationTableAdapter" GeneratorDataComponentClassName="BreakerOperationTableAdapter" Name="BreakerOperation" UserDataComponentName="BreakerOperationTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="openXDAConnectionString (Settings)" DbObjectName="openXDA.dbo.BreakerOperation" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[BreakerOperation] WHERE (([ID] = @Original_ID) AND ([EventID] = @Original_EventID) AND ([PhaseID] = @Original_PhaseID) AND ([BreakerOperationTypeID] = @Original_BreakerOperationTypeID) AND ([BreakerNumber] = @Original_BreakerNumber) AND ([TripCoilEnergized] = @Original_TripCoilEnergized) AND ([StatusBitSet] = @Original_StatusBitSet) AND ([APhaseCleared] = @Original_APhaseCleared) AND ([BPhaseCleared] = @Original_BPhaseCleared) AND ([CPhaseCleared] = @Original_CPhaseCleared) AND ([BreakerTiming] = @Original_BreakerTiming) AND ([APhaseBreakerTiming] = @Original_APhaseBreakerTiming) AND ([BPhaseBreakerTiming] = @Original_BPhaseBreakerTiming) AND ([CPhaseBreakerTiming] = @Original_CPhaseBreakerTiming) AND ([BreakerSpeed] = @Original_BreakerSpeed))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_EventID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EventID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_PhaseID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PhaseID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_BreakerOperationTypeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="BreakerOperationTypeID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_BreakerNumber" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="BreakerNumber" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime2" Direction="Input" ParameterName="@Original_TripCoilEnergized" Precision="0" ProviderType="DateTime2" Scale="0" Size="0" SourceColumn="TripCoilEnergized" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime2" Direction="Input" ParameterName="@Original_StatusBitSet" Precision="0" ProviderType="DateTime2" Scale="0" Size="0" SourceColumn="StatusBitSet" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime2" Direction="Input" ParameterName="@Original_APhaseCleared" Precision="0" ProviderType="DateTime2" Scale="0" Size="0" SourceColumn="APhaseCleared" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime2" Direction="Input" ParameterName="@Original_BPhaseCleared" Precision="0" ProviderType="DateTime2" Scale="0" Size="0" SourceColumn="BPhaseCleared" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime2" Direction="Input" ParameterName="@Original_CPhaseCleared" Precision="0" ProviderType="DateTime2" Scale="0" Size="0" SourceColumn="CPhaseCleared" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_BreakerTiming" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="BreakerTiming" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_APhaseBreakerTiming" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="APhaseBreakerTiming" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_BPhaseBreakerTiming" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="BPhaseBreakerTiming" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_CPhaseBreakerTiming" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="CPhaseBreakerTiming" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_BreakerSpeed" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="BreakerSpeed" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[BreakerOperation] ([EventID], [PhaseID], [BreakerOperationTypeID], [BreakerNumber], [TripCoilEnergized], [StatusBitSet], [APhaseCleared], [BPhaseCleared], [CPhaseCleared], [BreakerTiming], [APhaseBreakerTiming], [BPhaseBreakerTiming], [CPhaseBreakerTiming], [BreakerSpeed]) VALUES (@EventID, @PhaseID, @BreakerOperationTypeID, @BreakerNumber, @TripCoilEnergized, @StatusBitSet, @APhaseCleared, @BPhaseCleared, @CPhaseCleared, @BreakerTiming, @APhaseBreakerTiming, @BPhaseBreakerTiming, @CPhaseBreakerTiming, @BreakerSpeed);
SELECT ID, EventID, PhaseID, BreakerOperationTypeID, BreakerNumber, TripCoilEnergized, StatusBitSet, APhaseCleared, BPhaseCleared, CPhaseCleared, BreakerTiming, APhaseBreakerTiming, BPhaseBreakerTiming, CPhaseBreakerTiming, BreakerSpeed FROM BreakerOperation WHERE (ID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@EventID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EventID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@PhaseID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PhaseID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@BreakerOperationTypeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="BreakerOperationTypeID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@BreakerNumber" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="BreakerNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime2" Direction="Input" ParameterName="@TripCoilEnergized" Precision="0" ProviderType="DateTime2" Scale="0" Size="0" SourceColumn="TripCoilEnergized" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime2" Direction="Input" ParameterName="@StatusBitSet" Precision="0" ProviderType="DateTime2" Scale="0" Size="0" SourceColumn="StatusBitSet" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime2" Direction="Input" ParameterName="@APhaseCleared" Precision="0" ProviderType="DateTime2" Scale="0" Size="0" SourceColumn="APhaseCleared" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime2" Direction="Input" ParameterName="@BPhaseCleared" Precision="0" ProviderType="DateTime2" Scale="0" Size="0" SourceColumn="BPhaseCleared" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime2" Direction="Input" ParameterName="@CPhaseCleared" Precision="0" ProviderType="DateTime2" Scale="0" Size="0" SourceColumn="CPhaseCleared" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@BreakerTiming" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="BreakerTiming" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@APhaseBreakerTiming" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="APhaseBreakerTiming" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@BPhaseBreakerTiming" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="BPhaseBreakerTiming" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@CPhaseBreakerTiming" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="CPhaseBreakerTiming" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@BreakerSpeed" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="BreakerSpeed" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID, EventID, PhaseID, BreakerOperationTypeID, BreakerNumber, TripCoilEnergized, StatusBitSet, APhaseCleared, BPhaseCleared, CPhaseCleared, BreakerTiming, APhaseBreakerTiming, BPhaseBreakerTiming, CPhaseBreakerTiming, BreakerSpeed FROM dbo.BreakerOperation</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[BreakerOperation] SET [EventID] = @EventID, [PhaseID] = @PhaseID, [BreakerOperationTypeID] = @BreakerOperationTypeID, [BreakerNumber] = @BreakerNumber, [TripCoilEnergized] = @TripCoilEnergized, [StatusBitSet] = @StatusBitSet, [APhaseCleared] = @APhaseCleared, [BPhaseCleared] = @BPhaseCleared, [CPhaseCleared] = @CPhaseCleared, [BreakerTiming] = @BreakerTiming, [APhaseBreakerTiming] = @APhaseBreakerTiming, [BPhaseBreakerTiming] = @BPhaseBreakerTiming, [CPhaseBreakerTiming] = @CPhaseBreakerTiming, [BreakerSpeed] = @BreakerSpeed WHERE (([ID] = @Original_ID) AND ([EventID] = @Original_EventID) AND ([PhaseID] = @Original_PhaseID) AND ([BreakerOperationTypeID] = @Original_BreakerOperationTypeID) AND ([BreakerNumber] = @Original_BreakerNumber) AND ([TripCoilEnergized] = @Original_TripCoilEnergized) AND ([StatusBitSet] = @Original_StatusBitSet) AND ([APhaseCleared] = @Original_APhaseCleared) AND ([BPhaseCleared] = @Original_BPhaseCleared) AND ([CPhaseCleared] = @Original_CPhaseCleared) AND ([BreakerTiming] = @Original_BreakerTiming) AND ([APhaseBreakerTiming] = @Original_APhaseBreakerTiming) AND ([BPhaseBreakerTiming] = @Original_BPhaseBreakerTiming) AND ([CPhaseBreakerTiming] = @Original_CPhaseBreakerTiming) AND ([BreakerSpeed] = @Original_BreakerSpeed));
SELECT ID, EventID, PhaseID, BreakerOperationTypeID, BreakerNumber, TripCoilEnergized, StatusBitSet, APhaseCleared, BPhaseCleared, CPhaseCleared, BreakerTiming, APhaseBreakerTiming, BPhaseBreakerTiming, CPhaseBreakerTiming, BreakerSpeed FROM BreakerOperation WHERE (ID = @ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@EventID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EventID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@PhaseID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PhaseID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@BreakerOperationTypeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="BreakerOperationTypeID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@BreakerNumber" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="BreakerNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime2" Direction="Input" ParameterName="@TripCoilEnergized" Precision="0" ProviderType="DateTime2" Scale="0" Size="0" SourceColumn="TripCoilEnergized" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime2" Direction="Input" ParameterName="@StatusBitSet" Precision="0" ProviderType="DateTime2" Scale="0" Size="0" SourceColumn="StatusBitSet" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime2" Direction="Input" ParameterName="@APhaseCleared" Precision="0" ProviderType="DateTime2" Scale="0" Size="0" SourceColumn="APhaseCleared" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime2" Direction="Input" ParameterName="@BPhaseCleared" Precision="0" ProviderType="DateTime2" Scale="0" Size="0" SourceColumn="BPhaseCleared" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime2" Direction="Input" ParameterName="@CPhaseCleared" Precision="0" ProviderType="DateTime2" Scale="0" Size="0" SourceColumn="CPhaseCleared" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@BreakerTiming" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="BreakerTiming" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@APhaseBreakerTiming" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="APhaseBreakerTiming" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@BPhaseBreakerTiming" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="BPhaseBreakerTiming" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@CPhaseBreakerTiming" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="CPhaseBreakerTiming" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@BreakerSpeed" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="BreakerSpeed" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_EventID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EventID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_PhaseID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PhaseID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_BreakerOperationTypeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="BreakerOperationTypeID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_BreakerNumber" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="BreakerNumber" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime2" Direction="Input" ParameterName="@Original_TripCoilEnergized" Precision="0" ProviderType="DateTime2" Scale="0" Size="0" SourceColumn="TripCoilEnergized" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime2" Direction="Input" ParameterName="@Original_StatusBitSet" Precision="0" ProviderType="DateTime2" Scale="0" Size="0" SourceColumn="StatusBitSet" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime2" Direction="Input" ParameterName="@Original_APhaseCleared" Precision="0" ProviderType="DateTime2" Scale="0" Size="0" SourceColumn="APhaseCleared" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime2" Direction="Input" ParameterName="@Original_BPhaseCleared" Precision="0" ProviderType="DateTime2" Scale="0" Size="0" SourceColumn="BPhaseCleared" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime2" Direction="Input" ParameterName="@Original_CPhaseCleared" Precision="0" ProviderType="DateTime2" Scale="0" Size="0" SourceColumn="CPhaseCleared" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_BreakerTiming" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="BreakerTiming" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_APhaseBreakerTiming" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="APhaseBreakerTiming" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_BPhaseBreakerTiming" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="BPhaseBreakerTiming" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_CPhaseBreakerTiming" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="CPhaseBreakerTiming" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_BreakerSpeed" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="BreakerSpeed" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="ID" ColumnName="ID" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="EventID" DataSetColumn="EventID" />
              <Mapping SourceColumn="PhaseID" DataSetColumn="PhaseID" />
              <Mapping SourceColumn="BreakerOperationTypeID" DataSetColumn="BreakerOperationTypeID" />
              <Mapping SourceColumn="BreakerNumber" DataSetColumn="BreakerNumber" />
              <Mapping SourceColumn="TripCoilEnergized" DataSetColumn="TripCoilEnergized" />
              <Mapping SourceColumn="StatusBitSet" DataSetColumn="StatusBitSet" />
              <Mapping SourceColumn="APhaseCleared" DataSetColumn="APhaseCleared" />
              <Mapping SourceColumn="BPhaseCleared" DataSetColumn="BPhaseCleared" />
              <Mapping SourceColumn="CPhaseCleared" DataSetColumn="CPhaseCleared" />
              <Mapping SourceColumn="BreakerTiming" DataSetColumn="BreakerTiming" />
              <Mapping SourceColumn="APhaseBreakerTiming" DataSetColumn="APhaseBreakerTiming" />
              <Mapping SourceColumn="BPhaseBreakerTiming" DataSetColumn="BPhaseBreakerTiming" />
              <Mapping SourceColumn="CPhaseBreakerTiming" DataSetColumn="CPhaseBreakerTiming" />
              <Mapping SourceColumn="BreakerSpeed" DataSetColumn="BreakerSpeed" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="MeterData" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="true" msprop:Generator_DataSetName="MeterData" msprop:Generator_UserDSName="MeterData">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="EventType" msprop:Generator_TableClassName="EventTypeDataTable" msprop:Generator_TableVarName="tableEventType" msprop:Generator_RowChangedName="EventTypeRowChanged" msprop:Generator_TablePropName="EventType" msprop:Generator_RowDeletingName="EventTypeRowDeleting" msprop:Generator_RowChangingName="EventTypeRowChanging" msprop:Generator_RowEvHandlerName="EventTypeRowChangeEventHandler" msprop:Generator_RowDeletedName="EventTypeRowDeleted" msprop:Generator_RowClassName="EventTypeRow" msprop:Generator_UserTableName="EventType" msprop:Generator_RowEvArgName="EventTypeRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_UserColumnName="ID" type="xs:int" />
              <xs:element name="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnPropNameInTable="NameColumn" msprop:Generator_UserColumnName="Name">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Description" msprop:Generator_ColumnVarNameInTable="columnDescription" msprop:Generator_ColumnPropNameInRow="Description" msprop:Generator_ColumnPropNameInTable="DescriptionColumn" msprop:Generator_UserColumnName="Description" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="ChannelNormal" msprop:Generator_TableClassName="ChannelNormalDataTable" msprop:Generator_TableVarName="tableChannelNormal" msprop:Generator_RowChangedName="ChannelNormalRowChanged" msprop:Generator_TablePropName="ChannelNormal" msprop:Generator_RowDeletingName="ChannelNormalRowDeleting" msprop:Generator_RowChangingName="ChannelNormalRowChanging" msprop:Generator_RowEvHandlerName="ChannelNormalRowChangeEventHandler" msprop:Generator_RowDeletedName="ChannelNormalRowDeleted" msprop:Generator_RowClassName="ChannelNormalRow" msprop:Generator_UserTableName="ChannelNormal" msprop:Generator_RowEvArgName="ChannelNormalRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_UserColumnName="ID" type="xs:int" />
              <xs:element name="ChannelID" msprop:Generator_ColumnVarNameInTable="columnChannelID" msprop:Generator_ColumnPropNameInRow="ChannelID" msprop:Generator_ColumnPropNameInTable="ChannelIDColumn" msprop:Generator_UserColumnName="ChannelID" type="xs:int" />
              <xs:element name="Average" msprop:Generator_ColumnVarNameInTable="columnAverage" msprop:Generator_ColumnPropNameInRow="Average" msprop:Generator_ColumnPropNameInTable="AverageColumn" msprop:Generator_UserColumnName="Average" type="xs:double" />
              <xs:element name="MeanSquare" msprop:Generator_ColumnVarNameInTable="columnMeanSquare" msprop:Generator_ColumnPropNameInRow="MeanSquare" msprop:Generator_ColumnPropNameInTable="MeanSquareColumn" msprop:Generator_UserColumnName="MeanSquare" type="xs:double" />
              <xs:element name="StandardDeviation" msprop:Generator_ColumnVarNameInTable="columnStandardDeviation" msprop:Generator_ColumnPropNameInRow="StandardDeviation" msprop:Generator_ColumnPropNameInTable="StandardDeviationColumn" msprop:Generator_UserColumnName="StandardDeviation" type="xs:double" />
              <xs:element name="Count" msprop:Generator_ColumnVarNameInTable="columnCount" msprop:Generator_ColumnPropNameInRow="Count" msprop:Generator_ColumnPropNameInTable="CountColumn" msprop:Generator_UserColumnName="Count" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="HourlyTrendingSummary" msprop:Generator_TableClassName="HourlyTrendingSummaryDataTable" msprop:Generator_TableVarName="tableHourlyTrendingSummary" msprop:Generator_RowChangedName="HourlyTrendingSummaryRowChanged" msprop:Generator_TablePropName="HourlyTrendingSummary" msprop:Generator_RowDeletingName="HourlyTrendingSummaryRowDeleting" msprop:Generator_RowChangingName="HourlyTrendingSummaryRowChanging" msprop:Generator_RowEvHandlerName="HourlyTrendingSummaryRowChangeEventHandler" msprop:Generator_RowDeletedName="HourlyTrendingSummaryRowDeleted" msprop:Generator_RowClassName="HourlyTrendingSummaryRow" msprop:Generator_UserTableName="HourlyTrendingSummary" msprop:Generator_RowEvArgName="HourlyTrendingSummaryRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_UserColumnName="ID" type="xs:int" />
              <xs:element name="ChannelID" msprop:Generator_ColumnVarNameInTable="columnChannelID" msprop:Generator_ColumnPropNameInRow="ChannelID" msprop:Generator_ColumnPropNameInTable="ChannelIDColumn" msprop:Generator_UserColumnName="ChannelID" type="xs:int" />
              <xs:element name="Time" msprop:Generator_ColumnVarNameInTable="columnTime" msprop:Generator_ColumnPropNameInRow="Time" msprop:Generator_ColumnPropNameInTable="TimeColumn" msprop:Generator_UserColumnName="Time" type="xs:dateTime" />
              <xs:element name="Minimum" msprop:Generator_ColumnVarNameInTable="columnMinimum" msprop:Generator_ColumnPropNameInRow="Minimum" msprop:Generator_ColumnPropNameInTable="MinimumColumn" msprop:Generator_UserColumnName="Minimum" type="xs:double" />
              <xs:element name="Maximum" msprop:Generator_ColumnVarNameInTable="columnMaximum" msprop:Generator_ColumnPropNameInRow="Maximum" msprop:Generator_ColumnPropNameInTable="MaximumColumn" msprop:Generator_UserColumnName="Maximum" type="xs:double" />
              <xs:element name="Average" msprop:Generator_ColumnVarNameInTable="columnAverage" msprop:Generator_ColumnPropNameInRow="Average" msprop:Generator_ColumnPropNameInTable="AverageColumn" msprop:Generator_UserColumnName="Average" type="xs:double" />
              <xs:element name="ValidCount" msprop:Generator_ColumnVarNameInTable="columnValidCount" msprop:Generator_ColumnPropNameInRow="ValidCount" msprop:Generator_ColumnPropNameInTable="ValidCountColumn" msprop:Generator_UserColumnName="ValidCount" type="xs:int" />
              <xs:element name="InvalidCount" msprop:Generator_ColumnVarNameInTable="columnInvalidCount" msprop:Generator_ColumnPropNameInRow="InvalidCount" msprop:Generator_ColumnPropNameInTable="InvalidCountColumn" msprop:Generator_UserColumnName="InvalidCount" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="DailyTrendingSummary" msprop:Generator_TableClassName="DailyTrendingSummaryDataTable" msprop:Generator_TableVarName="tableDailyTrendingSummary" msprop:Generator_RowChangedName="DailyTrendingSummaryRowChanged" msprop:Generator_TablePropName="DailyTrendingSummary" msprop:Generator_RowDeletingName="DailyTrendingSummaryRowDeleting" msprop:Generator_RowChangingName="DailyTrendingSummaryRowChanging" msprop:Generator_RowEvHandlerName="DailyTrendingSummaryRowChangeEventHandler" msprop:Generator_RowDeletedName="DailyTrendingSummaryRowDeleted" msprop:Generator_RowClassName="DailyTrendingSummaryRow" msprop:Generator_UserTableName="DailyTrendingSummary" msprop:Generator_RowEvArgName="DailyTrendingSummaryRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_UserColumnName="ID" type="xs:int" />
              <xs:element name="ChannelID" msprop:Generator_ColumnVarNameInTable="columnChannelID" msprop:Generator_ColumnPropNameInRow="ChannelID" msprop:Generator_ColumnPropNameInTable="ChannelIDColumn" msprop:Generator_UserColumnName="ChannelID" type="xs:int" />
              <xs:element name="Date" msprop:Generator_ColumnVarNameInTable="columnDate" msprop:Generator_ColumnPropNameInRow="Date" msprop:Generator_ColumnPropNameInTable="DateColumn" msprop:Generator_UserColumnName="Date" type="xs:dateTime" />
              <xs:element name="Minimum" msprop:Generator_ColumnVarNameInTable="columnMinimum" msprop:Generator_ColumnPropNameInRow="Minimum" msprop:Generator_ColumnPropNameInTable="MinimumColumn" msprop:Generator_UserColumnName="Minimum" type="xs:double" />
              <xs:element name="Maximum" msprop:Generator_ColumnVarNameInTable="columnMaximum" msprop:Generator_ColumnPropNameInRow="Maximum" msprop:Generator_ColumnPropNameInTable="MaximumColumn" msprop:Generator_UserColumnName="Maximum" type="xs:double" />
              <xs:element name="Average" msprop:Generator_ColumnVarNameInTable="columnAverage" msprop:Generator_ColumnPropNameInRow="Average" msprop:Generator_ColumnPropNameInTable="AverageColumn" msprop:Generator_UserColumnName="Average" type="xs:double" />
              <xs:element name="ValidCount" msprop:Generator_ColumnVarNameInTable="columnValidCount" msprop:Generator_ColumnPropNameInRow="ValidCount" msprop:Generator_ColumnPropNameInTable="ValidCountColumn" msprop:Generator_UserColumnName="ValidCount" type="xs:int" />
              <xs:element name="InvalidCount" msprop:Generator_ColumnVarNameInTable="columnInvalidCount" msprop:Generator_ColumnPropNameInRow="InvalidCount" msprop:Generator_ColumnPropNameInTable="InvalidCountColumn" msprop:Generator_UserColumnName="InvalidCount" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="CycleData" msprop:Generator_TableClassName="CycleDataDataTable" msprop:Generator_TableVarName="tableCycleData" msprop:Generator_TablePropName="CycleData" msprop:Generator_RowDeletingName="CycleDataRowDeleting" msprop:Generator_RowChangingName="CycleDataRowChanging" msprop:Generator_RowEvHandlerName="CycleDataRowChangeEventHandler" msprop:Generator_RowDeletedName="CycleDataRowDeleted" msprop:Generator_UserTableName="CycleData" msprop:Generator_RowChangedName="CycleDataRowChanged" msprop:Generator_RowEvArgName="CycleDataRowChangeEvent" msprop:Generator_RowClassName="CycleDataRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_UserColumnName="ID" type="xs:int" />
              <xs:element name="EventID" msprop:Generator_ColumnVarNameInTable="columnEventID" msprop:Generator_ColumnPropNameInRow="EventID" msprop:Generator_ColumnPropNameInTable="EventIDColumn" msprop:Generator_UserColumnName="EventID" type="xs:int" />
              <xs:element name="Data" msprop:Generator_ColumnVarNameInTable="columnData" msprop:Generator_ColumnPropNameInRow="Data" msprop:Generator_ColumnPropNameInTable="DataColumn" msprop:Generator_UserColumnName="Data" type="xs:base64Binary" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Event" msprop:Generator_TableClassName="EventDataTable" msprop:Generator_TableVarName="tableEvent" msprop:Generator_TablePropName="Event" msprop:Generator_RowDeletingName="EventRowDeleting" msprop:Generator_RowChangingName="EventRowChanging" msprop:Generator_RowEvHandlerName="EventRowChangeEventHandler" msprop:Generator_RowDeletedName="EventRowDeleted" msprop:Generator_UserTableName="Event" msprop:Generator_RowChangedName="EventRowChanged" msprop:Generator_RowEvArgName="EventRowChangeEvent" msprop:Generator_RowClassName="EventRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_UserColumnName="ID" type="xs:int" />
              <xs:element name="FileGroupID" msprop:Generator_ColumnVarNameInTable="columnFileGroupID" msprop:Generator_ColumnPropNameInRow="FileGroupID" msprop:Generator_ColumnPropNameInTable="FileGroupIDColumn" msprop:Generator_UserColumnName="FileGroupID" type="xs:int" />
              <xs:element name="MeterID" msprop:Generator_ColumnVarNameInTable="columnMeterID" msprop:Generator_ColumnPropNameInRow="MeterID" msprop:Generator_ColumnPropNameInTable="MeterIDColumn" msprop:Generator_UserColumnName="MeterID" type="xs:int" />
              <xs:element name="LineID" msprop:Generator_ColumnVarNameInTable="columnLineID" msprop:Generator_ColumnPropNameInRow="LineID" msprop:Generator_ColumnPropNameInTable="LineIDColumn" msprop:Generator_UserColumnName="LineID" type="xs:int" />
              <xs:element name="EventTypeID" msprop:Generator_ColumnVarNameInTable="columnEventTypeID" msprop:Generator_ColumnPropNameInRow="EventTypeID" msprop:Generator_ColumnPropNameInTable="EventTypeIDColumn" msprop:Generator_UserColumnName="EventTypeID" type="xs:int" />
              <xs:element name="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnPropNameInTable="NameColumn" msprop:Generator_UserColumnName="Name">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Alias" msprop:Generator_ColumnVarNameInTable="columnAlias" msprop:Generator_ColumnPropNameInRow="Alias" msprop:Generator_ColumnPropNameInTable="AliasColumn" msprop:Generator_UserColumnName="Alias" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ShortName" msprop:Generator_ColumnVarNameInTable="columnShortName" msprop:Generator_ColumnPropNameInRow="ShortName" msprop:Generator_ColumnPropNameInTable="ShortNameColumn" msprop:Generator_UserColumnName="ShortName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="StartTime" msprop:Generator_ColumnVarNameInTable="columnStartTime" msprop:Generator_ColumnPropNameInRow="StartTime" msprop:Generator_ColumnPropNameInTable="StartTimeColumn" msprop:Generator_UserColumnName="StartTime" type="xs:dateTime" />
              <xs:element name="EndTime" msprop:Generator_ColumnVarNameInTable="columnEndTime" msprop:Generator_ColumnPropNameInRow="EndTime" msprop:Generator_ColumnPropNameInTable="EndTimeColumn" msprop:Generator_UserColumnName="EndTime" type="xs:dateTime" />
              <xs:element name="TimeZoneOffset" msprop:Generator_ColumnVarNameInTable="columnTimeZoneOffset" msprop:Generator_ColumnPropNameInRow="TimeZoneOffset" msprop:Generator_ColumnPropNameInTable="TimeZoneOffsetColumn" msprop:Generator_UserColumnName="TimeZoneOffset" type="xs:int" />
              <xs:element name="Magnitude" msprop:Generator_ColumnVarNameInTable="columnMagnitude" msprop:Generator_ColumnPropNameInRow="Magnitude" msprop:Generator_ColumnPropNameInTable="MagnitudeColumn" msprop:Generator_UserColumnName="Magnitude" type="xs:double" />
              <xs:element name="Duration" msprop:Generator_ColumnVarNameInTable="columnDuration" msprop:Generator_ColumnPropNameInRow="Duration" msprop:Generator_ColumnPropNameInTable="DurationColumn" msprop:Generator_UserColumnName="Duration" type="xs:double" />
              <xs:element name="HasImpactedComponents" msprop:Generator_ColumnVarNameInTable="columnHasImpactedComponents" msprop:Generator_ColumnPropNameInRow="HasImpactedComponents" msprop:Generator_ColumnPropNameInTable="HasImpactedComponentsColumn" msprop:Generator_UserColumnName="HasImpactedComponents" type="xs:int" />
              <xs:element name="Description" msprop:Generator_ColumnVarNameInTable="columnDescription" msprop:Generator_ColumnPropNameInRow="Description" msprop:Generator_ColumnPropNameInTable="DescriptionColumn" msprop:Generator_UserColumnName="Description" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Data" msprop:Generator_ColumnVarNameInTable="columnData" msprop:Generator_ColumnPropNameInRow="Data" msprop:Generator_ColumnPropNameInTable="DataColumn" msprop:Generator_UserColumnName="Data" type="xs:base64Binary" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="BreakerOperationType" msprop:Generator_TableClassName="BreakerOperationTypeDataTable" msprop:Generator_TableVarName="tableBreakerOperationType" msprop:Generator_TablePropName="BreakerOperationType" msprop:Generator_RowDeletingName="BreakerOperationTypeRowDeleting" msprop:Generator_RowChangingName="BreakerOperationTypeRowChanging" msprop:Generator_RowEvHandlerName="BreakerOperationTypeRowChangeEventHandler" msprop:Generator_RowDeletedName="BreakerOperationTypeRowDeleted" msprop:Generator_UserTableName="BreakerOperationType" msprop:Generator_RowChangedName="BreakerOperationTypeRowChanged" msprop:Generator_RowEvArgName="BreakerOperationTypeRowChangeEvent" msprop:Generator_RowClassName="BreakerOperationTypeRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_UserColumnName="ID" type="xs:int" />
              <xs:element name="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnPropNameInTable="NameColumn" msprop:Generator_UserColumnName="Name">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Description" msprop:Generator_ColumnVarNameInTable="columnDescription" msprop:Generator_ColumnPropNameInRow="Description" msprop:Generator_ColumnPropNameInTable="DescriptionColumn" msprop:Generator_UserColumnName="Description">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="BreakerOperation" msprop:Generator_TableClassName="BreakerOperationDataTable" msprop:Generator_TableVarName="tableBreakerOperation" msprop:Generator_TablePropName="BreakerOperation" msprop:Generator_RowDeletingName="BreakerOperationRowDeleting" msprop:Generator_RowChangingName="BreakerOperationRowChanging" msprop:Generator_RowEvHandlerName="BreakerOperationRowChangeEventHandler" msprop:Generator_RowDeletedName="BreakerOperationRowDeleted" msprop:Generator_UserTableName="BreakerOperation" msprop:Generator_RowChangedName="BreakerOperationRowChanged" msprop:Generator_RowEvArgName="BreakerOperationRowChangeEvent" msprop:Generator_RowClassName="BreakerOperationRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_UserColumnName="ID" type="xs:int" />
              <xs:element name="EventID" msprop:Generator_ColumnVarNameInTable="columnEventID" msprop:Generator_ColumnPropNameInRow="EventID" msprop:Generator_ColumnPropNameInTable="EventIDColumn" msprop:Generator_UserColumnName="EventID" type="xs:int" />
              <xs:element name="PhaseID" msprop:Generator_ColumnVarNameInTable="columnPhaseID" msprop:Generator_ColumnPropNameInRow="PhaseID" msprop:Generator_ColumnPropNameInTable="PhaseIDColumn" msprop:Generator_UserColumnName="PhaseID" type="xs:int" />
              <xs:element name="BreakerOperationTypeID" msprop:Generator_ColumnVarNameInTable="columnBreakerOperationTypeID" msprop:Generator_ColumnPropNameInRow="BreakerOperationTypeID" msprop:Generator_ColumnPropNameInTable="BreakerOperationTypeIDColumn" msprop:Generator_UserColumnName="BreakerOperationTypeID" type="xs:int" />
              <xs:element name="BreakerNumber" msprop:Generator_ColumnVarNameInTable="columnBreakerNumber" msprop:Generator_ColumnPropNameInRow="BreakerNumber" msprop:Generator_ColumnPropNameInTable="BreakerNumberColumn" msprop:Generator_UserColumnName="BreakerNumber">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="120" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TripCoilEnergized" msprop:Generator_ColumnVarNameInTable="columnTripCoilEnergized" msprop:Generator_ColumnPropNameInRow="TripCoilEnergized" msprop:Generator_ColumnPropNameInTable="TripCoilEnergizedColumn" msprop:Generator_UserColumnName="TripCoilEnergized" type="xs:dateTime" />
              <xs:element name="StatusBitSet" msprop:Generator_ColumnVarNameInTable="columnStatusBitSet" msprop:Generator_ColumnPropNameInRow="StatusBitSet" msprop:Generator_ColumnPropNameInTable="StatusBitSetColumn" msprop:Generator_UserColumnName="StatusBitSet" type="xs:dateTime" />
              <xs:element name="APhaseCleared" msprop:Generator_ColumnVarNameInTable="columnAPhaseCleared" msprop:Generator_ColumnPropNameInRow="APhaseCleared" msprop:Generator_ColumnPropNameInTable="APhaseClearedColumn" msprop:Generator_UserColumnName="APhaseCleared" type="xs:dateTime" />
              <xs:element name="BPhaseCleared" msprop:Generator_ColumnVarNameInTable="columnBPhaseCleared" msprop:Generator_ColumnPropNameInRow="BPhaseCleared" msprop:Generator_ColumnPropNameInTable="BPhaseClearedColumn" msprop:Generator_UserColumnName="BPhaseCleared" type="xs:dateTime" />
              <xs:element name="CPhaseCleared" msprop:Generator_ColumnVarNameInTable="columnCPhaseCleared" msprop:Generator_ColumnPropNameInRow="CPhaseCleared" msprop:Generator_ColumnPropNameInTable="CPhaseClearedColumn" msprop:Generator_UserColumnName="CPhaseCleared" type="xs:dateTime" />
              <xs:element name="BreakerTiming" msprop:Generator_ColumnVarNameInTable="columnBreakerTiming" msprop:Generator_ColumnPropNameInRow="BreakerTiming" msprop:Generator_ColumnPropNameInTable="BreakerTimingColumn" msprop:Generator_UserColumnName="BreakerTiming" type="xs:double" />
              <xs:element name="APhaseBreakerTiming" msprop:Generator_ColumnVarNameInTable="columnAPhaseBreakerTiming" msprop:Generator_ColumnPropNameInRow="APhaseBreakerTiming" msprop:Generator_ColumnPropNameInTable="APhaseBreakerTimingColumn" msprop:Generator_UserColumnName="APhaseBreakerTiming" type="xs:double" />
              <xs:element name="BPhaseBreakerTiming" msprop:Generator_ColumnVarNameInTable="columnBPhaseBreakerTiming" msprop:Generator_ColumnPropNameInRow="BPhaseBreakerTiming" msprop:Generator_ColumnPropNameInTable="BPhaseBreakerTimingColumn" msprop:Generator_UserColumnName="BPhaseBreakerTiming" type="xs:double" />
              <xs:element name="CPhaseBreakerTiming" msprop:Generator_ColumnVarNameInTable="columnCPhaseBreakerTiming" msprop:Generator_ColumnPropNameInRow="CPhaseBreakerTiming" msprop:Generator_ColumnPropNameInTable="CPhaseBreakerTimingColumn" msprop:Generator_UserColumnName="CPhaseBreakerTiming" type="xs:double" />
              <xs:element name="BreakerSpeed" msprop:Generator_ColumnVarNameInTable="columnBreakerSpeed" msprop:Generator_ColumnPropNameInRow="BreakerSpeed" msprop:Generator_ColumnPropNameInTable="BreakerSpeedColumn" msprop:Generator_UserColumnName="BreakerSpeed" type="xs:double" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:EventType" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="ChannelNormal_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:ChannelNormal" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="HourlyTrendingSummary_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:HourlyTrendingSummary" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="DailyTrendingSummary_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:DailyTrendingSummary" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="CycleData_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:CycleData" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="Event_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Event" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="BreakerOperationType_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:BreakerOperationType" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="BreakerOperation_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:BreakerOperation" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
  </xs:element>
</xs:schema>